IF NOT EXISTS(SELECT name FROM sysobjects  WHERE name = 'UsersUnavailableToAccounts')
BEGIN       
    CREATE TABLE [dbo].[UsersUnavailableToAccounts](
	[Id] [UNIQUEIDENTIFIER] NOT NULL,
	[Parent] [UNIQUEIDENTIFIER] NULL,
	[Code] [VARCHAR](20) NOT NULL,
	[Type] [TINYINT] NOT NULL,
    CONSTRAINT [PK_UsersUnavailableToAccounts] PRIMARY KEY CLUSTERED 
    (
	  [Id] ASC
    )
    ) ON [PRIMARY]
    ALTER TABLE [dbo].[UsersUnavailableToAccounts] ADD  CONSTRAINT [DF_UsersUnavailableToAccounts_Id]  DEFAULT (NEWID()) FOR [Id]
    ALTER TABLE [dbo].[UsersUnavailableToAccounts] ADD  CONSTRAINT [DF_UsersUnavailableToAccounts_Type]  DEFAULT ((1)) FOR [Type]
END 